<?php

namespace app\admin\controller;

use app\common\controller\Backend;

/**
 * 会员余额变动管理
 *
 * @icon fa fa-circle-o
 */
class Blindlog extends Backend
{

    /**
     * Blindlog模型对象
     * @var \app\admin\model\Blindlog
     */
    protected $model = null;

    public function _initialize()
    {
        parent::_initialize();
        $this->model = new \app\admin\model\Blindlog;
        $number = db("user")
            ->where("lamp",1)
            ->where("save_money",">",0)
            ->where("blind_times",">",0)
            ->where("blind_times","<",34)
            ->count();
        $this->view->assign('number',$number);
        $yiyong = db("user_money_log")
            ->where('memo',"盲盒奖励")
            ->where('type',"prize_draw")
            ->whereTime("createtime","today")
            ->count();

        $this->view->assign('yiyong',$yiyong);
        $zongliang = db("user_blind_log")
            ->sum("money");
        $shiyopng = db("user_blind_log")
            ->sum("use_money");
        $this->view->assign('zongliang',bcsub($zongliang,$shiyopng,2));


        $money = db("user_blind_log")->sum("money") - db("user_blind_log")->sum("use_money");
        $money = bcmul($money, 0.03,2);
        $times = db("user")->where("lamp",1)->sum("save_money");
        $score = bcmul(bcdiv($money,$times,4) , 100,2);


        $this->view->assign('kechou',$score);

    }

    public function index()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags', 'trim']);
        if (false === $this->request->isAjax()) {
            return $this->view->fetch();
        }
        //如果发送的来源是 Selectpage，则转发到 Selectpage
        if ($this->request->request('keyField')) {
            return $this->selectpage();
        }
        [$where, $sort, $order, $offset, $limit] = $this->buildparams();
        $list = $this->model
            ->where($where)
//            ->order($sort, $order)
            ->order("id asc")
            ->paginate($limit);
        $result = ['total' => $list->total(), 'rows' => $list->items()];
        return json($result);
    }


    /**
     * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
     * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
     * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
     */


}
